# 作者: YYJ
# 2025年07月19日15时19分49秒
# 2486249622@qq.com
from pymysql import *

def main_dml():
    conn = connect(host='192.168.88.134', port=3306, user='root'
                   , password='123', database='python10', charset='utf8')
    cursor = conn.cursor()
    sql = ("insert into students(name, age, height, gender, cls_id, is_delete) "
           "values(%s,%s,%s,%s,%s,%s)")
    count = cursor.execute(sql, ['张三', 18, 174.00, '男', 2, 1])
    print(count)
    conn.commit()
    cursor.close()
    conn.close()

if __name__ == '__main__':
    main_dml()